<?php

/**
 * Adds the flickr slide type
 *
 */
class Db_007_bbce_add_flickr_slide_type extends Ot_Migrate_Migration_Abstract
{
    public function up($dba)
    {
        $query = "
                
            CREATE TABLE IF NOT EXISTS `" . $this->tablePrefix . "tbl_plugin_slidetype_flickr` (
              `slideId` int(11) NOT NULL,
              `tags` text CHARACTER SET utf8 NOT NULL,
              `bgColor` varchar(6) NOT NULL,
              `alignment` enum('topLeft','topCenter','topRight','centerLeft','centerCenter','centerRight','bottomLeft','bottomCenter','bottomRight') CHARACTER SET utf8 NOT NULL DEFAULT 'centerCenter',
              `scaling` enum('none','up','down','fill') NOT NULL,
              PRIMARY KEY (`slideId`)
            ) ENGINE=InnoDB DEFAULT CHARSET=latin1
        
        ";
        
        $dba->query($query);
    }

    public function down($dba) {
        
    }    
}